package com.yonyou.gmmc.service.shopping.model;

import java.util.Date;
import javax.persistence.*;

import org.jeecgframework.poi.excel.annotation.Excel;
import org.springframework.format.annotation.DateTimeFormat;

import com.fasterxml.jackson.annotation.JsonFormat;

@Table(name = "TM_TP_ORDER_INFO")
public class TmTpOrderInfo {
    @Id
    @Column(name = "ORDER_ID")
    @SequenceGenerator(name="",sequenceName="SEQ_TM_TP_ORDER_INFO")
    private Long orderId;
    
    @Column(name = "THIRD_ORDER")
    @Excel(name="订单编号",width=28)
    private String thirdOrder;
    
    //京东订单编号
    @Column(name = "JD_ORDER_ID")
    @Excel(name="京东订单编号",width=28)
    private String jdOrderId;

    @Column(name = "USER_ID")
    private Long userId;
    
    @Column(name = "SKU")
    private String sku;

    @Column(name = "ORDER_STATUS")
    private String orderStatus;
    
    //下单人姓名
    @Column(name = "CAR_OWNER_NAME")
    @Excel(name="下单人姓名")
    private String carOwnerName;
    
    //下单电话
    @Column(name = "PHONE")
    @Excel(name="下单人电话",width=13)
    private String phone;
    
    @Column(name = "SOURCE_TYPE")
    @Excel(name="订单来源")
    private String sourceType;//用户类型

    @Column(name = "NAME")
    @Excel(name="姓名")
    private String name;

    @Column(name = "PROVINCE")
    private Long province;

    @Column(name = "CITY")
    private Long city;

    @Column(name = "COUNTY")
    private Long county;

    @Column(name = "TOWN")
    private Long town;

    @Column(name = "ADDRESS")
    private String address;

    @Column(name = "ZIP")
    private String zip;


    
    @Column(name = "MOBILE")
    @Excel(name="联系电话",width=13)
    private String mobile;
    
    

    @Column(name = "EMAIL")
    private String email;

    @Column(name = "REMARK")
    private String remark;

    @Column(name = "INVOICE_STATE")
    private Long invoiceState;

    @Column(name = "INVOICE_TYPE")
    private Long invoiceType;

    @Column(name = "SELECTED_INVOICE_TITLE")
    private Long selectedInvoiceTitle;

    @Column(name = "COMPANY_NAME")
    private String companyName;

    @Column(name = "INVOICE_CONTENT")
    private Long invoiceContent;

    @Column(name = "PAYMENT_TYPE")
    private Long paymentType;

    @Column(name = "IS_USE_BALANCE")
    private Long isUseBalance;

    @Column(name = "SUBMIT_STATE")
    private Long submitState;

    @Column(name = "INVOICE_NAME")
    private String invoiceName;

    @Column(name = "INVOICE_PHONE")
    private String invoicePhone;

    @Column(name = "INVOICE_PROVICE")
    private Long invoiceProvice;

    @Column(name = "INVOICE_CITY")
    private Long invoiceCity;

    @Column(name = "INVOICE_COUNTY")
    private Long invoiceCounty;

    @Column(name = "INVOICE_ADDRESS")
    private String invoiceAddress;

    @Column(name = "DO_ORDER_PRICE_MODE")
    private Long doOrderPriceMode;

    @Column(name = "ORDER_PRICE_SNAP")
    private String orderPriceSnap;

    @Column(name = "RESERVING_DATE")
    private Long reservingDate;

    @Column(name = "INSTALL_DATE")
    private Long installDate;

    @Column(name = "NEED_INSTALL")
    private String needInstall;

    @Column(name = "PROMISE_DATE")
    private String promiseDate;

    @Column(name = "PROMISE_TIME_RANGE")
    private String promiseTimeRange;

    @Column(name = "PROMISE_TIME_RANGE_CODE")
    private Long promiseTimeRangeCode;

    

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @Column(name = "UPDATE_DATE")
    private Date updateDate;

    

    @Column(name = "FREIGHT")
    private String freight;

    

    @Column(name = "ORDER_NAKED_PRICE")
    private String orderNakedPrice;

    @Column(name = "ORDER_TAX_PRICE")
    private String orderTaxPrice;

    @Column(name = "JD_CODE")
    private String jdCode;
    
    /**
     * 订单列表使用
     */
    //@Column(name = "CODE_NAME")
    @Excel(name="订单状态")
    private String codeName;
    
    /**
     * PC订单列表使用
     */
    //@Column(name = "PRODUCT_INFO")
    @Excel(name="订单明细",width=60,height=20)
    private String productInfo;
    
    //京东价格
    @Column(name = "ORDER_PRICE")
    @Excel(name="JD价格")
    private String orderPrice;
    
    //@Column(name = "SUM_PRICE")
    @Excel(name="订单金额")
    private String sumPrice;
    
    /*
     * 
     */
    private String jdPrice;
    
    //@Column(name = "SEND_ADDRESS")
    private String sendAddress;//送货地址
    
    
    
    public String getSourceType() {
		return sourceType;
	}

	public void setSourceType(String sourceType) {
		this.sourceType = sourceType;
	}

	public String getSendAddress() {
		return sendAddress;
	}

	public void setSendAddress(String sendAddress) {
		this.sendAddress = sendAddress;
	}

	public String getSumPrice() {
		return sumPrice;
	}

	public void setSumPrice(String sumPrice) {
		this.sumPrice = sumPrice;
	}


    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @Column(name = "CREATE_DATE")
    @Excel(name="订单时间",format="yyyy-MM-dd HH:mm:ss",width=20)
    private Date createDate;
    
    

    public String getCarOwnerName() {
		return carOwnerName;
	}

	public void setCarOwnerName(String carOwnerName) {
		this.carOwnerName = carOwnerName;
	}

	public String getProductInfo() {
		return productInfo;
	}

	public void setProductInfo(String productInfo) {
		this.productInfo = productInfo;
	}

	public String getCodeName() {
		return codeName;
	}

	public void setCodeName(String codeName) {
		this.codeName = codeName;
	}

	/**
     * @return THIRD_ORDER
     */
    public String getThirdOrder() {
        return thirdOrder;
    }

    /**
     * @param thirdOrder
     */
    public void setThirdOrder(String thirdOrder) {
        this.thirdOrder = thirdOrder;
    }

    /**
     * @return SKU
     */
    public String getSku() {
        return sku;
    }

    /**
     * @param sku
     */
    public void setSku(String sku) {
        this.sku = sku;
    }

    /**
     * @return ORDER_STATUS
     */
    public String getOrderStatus() {
        return orderStatus;
    }

    /**
     * @param orderStatus
     */
    public void setOrderStatus(String orderStatus) {
        this.orderStatus = orderStatus;
    }

    /**
     * @return NAME
     */
    public String getName() {
        return name;
    }

    /**
     * @param name
     */
    public void setName(String name) {
        this.name = name;
    }

    /**
     * @return PROVINCE
     */
    public Long getProvince() {
        return province;
    }

    /**
     * @param province
     */
    public void setProvince(Long province) {
        this.province = province;
    }

    /**
     * @return CITY
     */
    public Long getCity() {
        return city;
    }

    /**
     * @param city
     */
    public void setCity(Long city) {
        this.city = city;
    }

    /**
     * @return COUNTY
     */
    public Long getCounty() {
        return county;
    }

    /**
     * @param county
     */
    public void setCounty(Long county) {
        this.county = county;
    }

    /**
     * @return TOWN
     */
    public Long getTown() {
        return town;
    }

    /**
     * @param town
     */
    public void setTown(Long town) {
        this.town = town;
    }

    /**
     * @return ADDRESS
     */
    public String getAddress() {
        return address;
    }

    /**
     * @param address
     */
    public void setAddress(String address) {
        this.address = address;
    }

    /**
     * @return ZIP
     */
    public String getZip() {
        return zip;
    }

    /**
     * @param zip
     */
    public void setZip(String zip) {
        this.zip = zip;
    }

    /**
     * @return PHONE
     */
    public String getPhone() {
        return phone;
    }

    /**
     * @param phone
     */
    public void setPhone(String phone) {
        this.phone = phone;
    }

    /**
     * @return MOBILE
     */
    public String getMobile() {
        return mobile;
    }

    /**
     * @param mobile
     */
    public void setMobile(String mobile) {
        this.mobile = mobile;
    }

    /**
     * @return EMAIL
     */
    public String getEmail() {
        return email;
    }

    /**
     * @param email
     */
    public void setEmail(String email) {
        this.email = email;
    }

    /**
     * @return REMARK
     */
    public String getRemark() {
        return remark;
    }

    /**
     * @param remark
     */
    public void setRemark(String remark) {
        this.remark = remark;
    }

    /**
     * @return INVOICE_STATE
     */
    public Long getInvoiceState() {
        return invoiceState;
    }

    /**
     * @param invoiceState
     */
    public void setInvoiceState(Long invoiceState) {
        this.invoiceState = invoiceState;
    }

    /**
     * @return INVOICE_TYPE
     */
    public Long getInvoiceType() {
        return invoiceType;
    }

    /**
     * @param invoiceType
     */
    public void setInvoiceType(Long invoiceType) {
        this.invoiceType = invoiceType;
    }

    /**
     * @return SELECTED_INVOICE_TITLE
     */
    public Long getSelectedInvoiceTitle() {
        return selectedInvoiceTitle;
    }

    /**
     * @param selectedInvoiceTitle
     */
    public void setSelectedInvoiceTitle(Long selectedInvoiceTitle) {
        this.selectedInvoiceTitle = selectedInvoiceTitle;
    }

    /**
     * @return COMPANY_NAME
     */
    public String getCompanyName() {
        return companyName;
    }

    /**
     * @param companyName
     */
    public void setCompanyName(String companyName) {
        this.companyName = companyName;
    }

    /**
     * @return INVOICE_CONTENT
     */
    public Long getInvoiceContent() {
        return invoiceContent;
    }

    /**
     * @param invoiceContent
     */
    public void setInvoiceContent(Long invoiceContent) {
        this.invoiceContent = invoiceContent;
    }

    /**
     * @return PAYMENT_TYPE
     */
    public Long getPaymentType() {
        return paymentType;
    }

    /**
     * @param paymentType
     */
    public void setPaymentType(Long paymentType) {
        this.paymentType = paymentType;
    }

    /**
     * @return IS_USE_BALANCE
     */
    public Long getIsUseBalance() {
        return isUseBalance;
    }

    /**
     * @param isUseBalance
     */
    public void setIsUseBalance(Long isUseBalance) {
        this.isUseBalance = isUseBalance;
    }

    /**
     * @return SUBMIT_STATE
     */
    public Long getSubmitState() {
        return submitState;
    }

    /**
     * @param submitState
     */
    public void setSubmitState(Long submitState) {
        this.submitState = submitState;
    }

    /**
     * @return INVOICE_NAME
     */
    public String getInvoiceName() {
        return invoiceName;
    }

    /**
     * @param invoiceName
     */
    public void setInvoiceName(String invoiceName) {
        this.invoiceName = invoiceName;
    }

    /**
     * @return INVOICE_PHONE
     */
    public String getInvoicePhone() {
        return invoicePhone;
    }

    /**
     * @param invoicePhone
     */
    public void setInvoicePhone(String invoicePhone) {
        this.invoicePhone = invoicePhone;
    }

    /**
     * @return INVOICE_PROVICE
     */
    public Long getInvoiceProvice() {
        return invoiceProvice;
    }

    /**
     * @param invoiceProvice
     */
    public void setInvoiceProvice(Long invoiceProvice) {
        this.invoiceProvice = invoiceProvice;
    }

    /**
     * @return INVOICE_CITY
     */
    public Long getInvoiceCity() {
        return invoiceCity;
    }

    /**
     * @param invoiceCity
     */
    public void setInvoiceCity(Long invoiceCity) {
        this.invoiceCity = invoiceCity;
    }

    /**
     * @return INVOICE_COUNTY
     */
    public Long getInvoiceCounty() {
        return invoiceCounty;
    }

    /**
     * @param invoiceCounty
     */
    public void setInvoiceCounty(Long invoiceCounty) {
        this.invoiceCounty = invoiceCounty;
    }

    /**
     * @return INVOICE_ADDRESS
     */
    public String getInvoiceAddress() {
        return invoiceAddress;
    }

    /**
     * @param invoiceAddress
     */
    public void setInvoiceAddress(String invoiceAddress) {
        this.invoiceAddress = invoiceAddress;
    }

    /**
     * @return DO_ORDER_PRICE_MODE
     */
    public Long getDoOrderPriceMode() {
        return doOrderPriceMode;
    }

    /**
     * @param doOrderPriceMode
     */
    public void setDoOrderPriceMode(Long doOrderPriceMode) {
        this.doOrderPriceMode = doOrderPriceMode;
    }

    /**
     * @return ORDER_PRICE_SNAP
     */
    public String getOrderPriceSnap() {
        return orderPriceSnap;
    }

    /**
     * @param orderPriceSnap
     */
    public void setOrderPriceSnap(String orderPriceSnap) {
        this.orderPriceSnap = orderPriceSnap;
    }

    /**
     * @return RESERVING_DATE
     */
    public Long getReservingDate() {
        return reservingDate;
    }

    /**
     * @param reservingDate
     */
    public void setReservingDate(Long reservingDate) {
        this.reservingDate = reservingDate;
    }

    /**
     * @return INSTALL_DATE
     */
    public Long getInstallDate() {
        return installDate;
    }

    /**
     * @param installDate
     */
    public void setInstallDate(Long installDate) {
        this.installDate = installDate;
    }

    /**
     * @return NEED_INSTALL
     */
    public String getNeedInstall() {
        return needInstall;
    }

    /**
     * @param needInstall
     */
    public void setNeedInstall(String needInstall) {
        this.needInstall = needInstall;
    }

    /**
     * @return PROMISE_DATE
     */
    public String getPromiseDate() {
        return promiseDate;
    }

    /**
     * @param promiseDate
     */
    public void setPromiseDate(String promiseDate) {
        this.promiseDate = promiseDate;
    }

    /**
     * @return PROMISE_TIME_RANGE
     */
    public String getPromiseTimeRange() {
        return promiseTimeRange;
    }

    /**
     * @param promiseTimeRange
     */
    public void setPromiseTimeRange(String promiseTimeRange) {
        this.promiseTimeRange = promiseTimeRange;
    }

    /**
     * @return PROMISE_TIME_RANGE_CODE
     */
    public Long getPromiseTimeRangeCode() {
        return promiseTimeRangeCode;
    }

    /**
     * @param promiseTimeRangeCode
     */
    public void setPromiseTimeRangeCode(Long promiseTimeRangeCode) {
        this.promiseTimeRangeCode = promiseTimeRangeCode;
    }

    /**
     * @return CREATE_DATE
     */
    public Date getCreateDate() {
        return createDate;
    }

    /**
     * @param createDate
     */
    public void setCreateDate(Date createDate) {
        this.createDate = createDate;
    }

    /**
     * @return UPDATE_DATE
     */
    public Date getUpdateDate() {
        return updateDate;
    }

    /**
     * @param updateDate
     */
    public void setUpdateDate(Date updateDate) {
        this.updateDate = updateDate;
    }

    
    /**
     * @return the userId
     */
    public Long getUserId() {
        return userId;
    }

    
    /**
     * @param userId the userId to set
     */
    public void setUserId(Long userId) {
        this.userId = userId;
    }

    
    /**
     * @return the jdOrderId
     */
    public String getJdOrderId() {
        return jdOrderId;
    }

    
    /**
     * @param jdOrderId the jdOrderId to set
     */
    public void setJdOrderId(String jdOrderId) {
        this.jdOrderId = jdOrderId;
    }

    
    /**
     * @return the freight
     */
    public String getFreight() {
        return freight;
    }

    
    /**
     * @param freight the freight to set
     */
    public void setFreight(String freight) {
        this.freight = freight;
    }

    
    /**
     * @return the orderPrice
     */
    public String getOrderPrice() {
        return orderPrice;
    }

    
    /**
     * @param orderPrice the orderPrice to set
     */
    public void setOrderPrice(String orderPrice) {
        this.orderPrice = orderPrice;
    }

    
    /**
     * @return the orderNakedPrice
     */
    public String getOrderNakedPrice() {
        return orderNakedPrice;
    }

    
    /**
     * @param orderNakedPrice the orderNakedPrice to set
     */
    public void setOrderNakedPrice(String orderNakedPrice) {
        this.orderNakedPrice = orderNakedPrice;
    }

    
    /**
     * @return the orderTaxPrice
     */
    public String getOrderTaxPrice() {
        return orderTaxPrice;
    }

    
    /**
     * @param orderTaxPrice the orderTaxPrice to set
     */
    public void setOrderTaxPrice(String orderTaxPrice) {
        this.orderTaxPrice = orderTaxPrice;
    }

    
    /**
     * @return the orderId
     */
    public Long getOrderId() {
        return orderId;
    }

    
    /**
     * @param orderId the orderId to set
     */
    public void setOrderId(Long orderId) {
        this.orderId = orderId;
    }

    
    /**
     * @return the jdCode
     */
    public String getJdCode() {
        return jdCode;
    }

    
    /**
     * @param jdCode the jdCode to set
     */
    public void setJdCode(String jdCode) {
        this.jdCode = jdCode;
    }

    
    /**
     * @return the jdPrice
     */
    public String getJdPrice() {
        return jdPrice;
    }

    
    /**
     * @param jdPrice the jdPrice to set
     */
    public void setJdPrice(String jdPrice) {
        this.jdPrice = jdPrice;
    }

}